package com.danny.mapper;

import com.danny.pojo.Room;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

import java.util.List;
@Mapper
@Repository
public interface RoomMapper {
    List<Room> queryAllRoom();
//    List<Room> queryRoomLimit(String roomNo,int page,int pageSize);
    List<Room> queryRoomLimitByNoParam(int page,int pageSize);
    int addRoom(Room room);
    int updateRoom(Room room);
    int deleteRoomById(int roomNo);
    Room queryRoomByRoomNo(int roomNo);
    //多属性查询
    List<Room> queryRoomByMul(Room room);
    List<Room> queryRoomByMulLimit(Room room,int page,int pageSize,int lowest,int highest);

    int RoomCount();

    int RoomCountHasInput(Room room,int lowest,int highest);
}
